home *** CD-ROM | disk | FTP | other *** search
- MYSQL(1) MYSQL(1)
-
-
-
- NNAAMMEE
- mysql - text-based client for mysqld, a SQL-based rela
- tional database daemon
-
- SSYYNNOOPPSSIISS
- mmyyssqqll [--BB|----bbaattcchh] [--##|----ddeebbuugg== _l_o_g_f_i_l_e] [--TT|----ddeebbuugg--iinnffoo]
- [--ee|----eexxeecc== _c_o_m_m_a_n_d] [--ff|----ffoorrccee] [--??|----hheellpp] [--hh|----hhoosstt==
- _h_o_s_t_n_a_m_e] [--nn|----uunnbbuuffffeerreedd] [--pp[[ppwwdd]]] [_-_-_p_a_s_s_w_o_r_d_=_[_p_w_d_]]
- [--PP|----ppoorrtt== _p_n_u_m] [--qq|----qquuiicckk] [--rr|----rraaww] [--ss|----ssiilleenntt]
- [--SS|----ssoocckkeett== _s_n_u_m] [--uu|----uusseerr== _u_n_a_m_e] [--vv|----vveerrbboossee]
- [--VV|----vveerrssiioonn] [--ww|----wwaaiitt]
-
- DDEESSCCRRIIPPTTIIOONN
- The _m_y_s_q_l program provides a curses-based interface to the
- SQL-based database server daemon, _m_y_s_q_l_d(1). Full fuller
- documentation, refer to the HTML documents installed with
- the package.
-
- OOPPTTIIOONNSS
- --BB|----bbaattcchh
- Print results with a tab as separator, each row on
- a new line.
-
- --##|----ddeebbuugg==_l_o_g_f_i_l_e
- Employ the specified debug log.
-
- --TT|----ddeebbuugg--iinnffoo
- Print debug information upon exiting.
-
- --ee || ----eexxeecc==ccoommmmaanndd
- Execute the specified command and quit ((--batch is
- implicit).
-
- --ff|----ffoorrccee
- Continue even if the face of a SQL error.
-
- --??|----hheellpp
- Display a help message and exit.
-
- --hh|----hhoosstt==_h_o_s_t_n_a_m_e
- Connect to the specified host.
-
- --nn|----uunnbbuuffffeerreedd
- Flush the buffer after each query.
-
- --pp|----ppaasssswwoorrdd[==_p_w_d]
- Employ the specified password when connecting to
- the database server. If a password is not sup
- plied, it will be requested interactively.
-
- --PP|----ppoorrtt==_p_n_u_m
- Employ the specified port number for connecting to
- the database server.
-
- --qq|----qquuiicckk
- Do not cache the result; print it row by row. This
- may slow down the server if the output is sus
- pended.
-
- --rr|----rraaww
- Write fields without conversion. (used with
- ----bbaattcchh).
-
- --ss|----ssiilleenntt
- Silent mode: reduce the amount of output.
-
- --SS|----ssoocckkeett==_s_n_u_m
- Employ the specified socket file for connecting to
- the database server.
-
- --uu|----uusseerr==_u_n_a_m_e
- Employ the specified user name for logging in to
- the server.
-
- --vv|----vveerrbboossee
- Verbose mode: write more Specifying this option
- _t_w_i_c_e produces a tabular output format.
-
- --VV|----vveerrssiioonn
- Print the _m_y_s_q_l version number and exit.
-
- --ww|----wwaaiitt
- Wait and retry if the database server connection is
- down.
-
- FFIILLEESS
- _/_d_e_p_o_t_/_b_i_n_/_m_y_s_q_l executable
-
- _/_d_e_p_o_t_/_b_i_n_/_m_y_s_q_l_d executable
-
- _/_d_e_p_o_t_/_b_i_n_/_s_a_f_e___m_y_s_q_l_d
- executable shell script for starting
- mysqld safely
-
- _/_s_i_t_e_/_v_a_r_/_m_y_s_q_l_/_d_a_t_a location of database files
-
- EEXXAAMMPPLLEE
- You can also read a backup dump file back into MySQL with:
-
- mmyyssqqll _d_a_t_a_b_a_s_e << backup-file.sql
-
- SSEEEE AALLSSOO
- isamchk (1), isamlog (1), mysqlaccess (1), mysqladmin (1),
- mysqlbug (1), mysqld (1), mysqldump (1), mysqlshow (1),
- msql2mysql (1), perror (1), replace (1), safe_mysqld (1),
- which1 (1), zap (1),
-
- AAUUTTHHOORR
- Ver 6.3, distribution 3.20.20 Michael (Monty) Widenius
- (monty@tcx.se), TCX Datakonsult AB (http://www.tcx.se).
- This software comes with no warranty. Manual page by R.
- P. C. Rodgers, Lister Hill National Center for Biomedical
- Communication, U.S. National Library of Medicine
- (rodgers@nlm.nih.gov).
-
-
-
- 13 June 1997 MYSQL(1)
-